package com.ccdc.lbcmsystem.mapper;


import com.ccdc.lbcmsystem.pojo.Children;
import com.ccdc.lbcmsystem.pojo.Gift;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

@Mapper
@Component
public interface GiftMapper {
    //查询所有用户
    List<Gift> queryGiftList();
    //通过姓名来进行查询
    List<Gift> queryListChildrenGiftByName(@RequestParam("name") String name);

    List<Gift> queryListGiftByName(@RequestParam("name") String name);


    List<Gift> queryListElderlyGiftByName(@RequestParam("name") String name);

    List<Gift> queryListVeteranGiftByName(@RequestParam("name") String name);
    //新增礼品信息
    int addGift(@RequestParam("children") Gift gift);
    //新增礼品信息
    int addChildrenGift(@RequestParam("children") Gift gift);
    //根据ID查询礼品信息
    Gift queryGiftById(@RequestParam("id") Integer id);
    //根据ID删除礼品信息
    int delGiftById(@RequestParam("id") Integer id);

    //查询妇联礼品信息
    List<Gift> queryChildrenGiftList();
    //查询村委会礼品信息
    List<Gift> queryElderlyGiftList();
    //查询军人办礼品信息
    List<Gift> queryVeteranGiftList();

    List<Gift> queryChildrenCheckedGiftList();

    List<Gift> queryElderlyCheckedGiftList();

    List<Gift> queryVeteranCheckedGiftList();

    List<Gift> queryChildrenUnCheckedGiftList();

    List<Gift> queryElderlyUnCheckedGiftList();

    List<Gift> queryVeteranUnCheckedGiftList();

    List<Gift> queryCheckedGiftList();

    List<Gift> queryUnCheckedGiftList();



}
